﻿CREATE TABLE [dbo].[ew_tbl_configurations]
(
    [ew_uid_configuration_id] UNIQUEIDENTIFIER NOT NULL , 
    [ew_vc_name] VARCHAR(512) NOT NULL, 
    [ew_vc_description] VARCHAR(1024) NULL, 
    [ew_xml_value_1] XML,
    [ew_xml_value_2] XML,
    [ew_xml_value_3] XML,
    [ew_xml_value_4] XML,
    [ew_xml_value_5] XML,
    [ew_xml_value_6] XML,
    [ew_xml_value_7] XML,
    [ew_xml_value_8] XML,
    [ew_xml_value_9] XML,
    [ew_dt_created] DATETIME NOT NULL, 
    [ew_nvc_created_by] NVARCHAR(1024) NOT NULL, 
    [ew_dt_modified] DATETIME NOT NULL, 
    [ew_nvc_modified_by] NVARCHAR(1024) NOT NULL, 
    [ew_t_timestamp] TIMESTAMP NOT NULL, 
    CONSTRAINT [ew_pk_tbl_configurations] PRIMARY KEY ([ew_uid_configuration_id])
)

GO

CREATE UNIQUE INDEX [ew_uk_tbl_configurations_name] ON [dbo].[ew_tbl_configurations] ([ew_vc_name])
